CREATE external TABLE jms_dim.dim_lq_agency_area_mapping_base (
  `id` bigint,
  `agency_code` string COMMENT '代理区编码',
  `area_id` string COMMENT    '行政区编码(关联 lq_service_site_new 的 city_code)',
  `created_time` TIMESTAMP COMMENT  '创建时间'

)  COMMENT  '代理区映射表'

STORED AS PARQUET
location
  '/dw/hive/jms_dim.db/external/dim_lq_agency_area_mapping_base'
TBLPROPERTIES (
  'parquet.column.index.access'='true'
)